Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_CONSTRAINTS

`ALL_CONSTRAINTS` describes constraint definitions on tables accessible to the current user.

Related Views

- `DBA_CONSTRAINTS` describes all constraint definitions in the database.

- `USER_CONSTRAINTS` describes constraint definitions on tables in the current user's schema.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the constraint definition
`CONSTRAINT_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the constraint definition
`CONSTRAINT_TYPE` | `VARCHAR2(1)` |  | Type of constraint definition: `C` (check constraint on a table) `P` (primary key) `U` (unique key) `R` (referential integrity) `V` (with check option, on a view) `O` (with read only, on a view)
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name associated with the table (or view) with constraint definition
`SEARCH_CONDITION` | `LONG` |  | Text of search condition for a check constraint
`R_OWNER` | `VARCHAR2(30)` |  | Owner of table referred to in a referential constraint
`R_CONSTRAINT_NAME` | `VARCHAR2(30)` |  | Name of the unique constraint definition for referenced table
`DELETE_RULE` | `VARCHAR2(9)` |  | Delete rule for a referential constraint (`CASCADE` or `NO ACTION`)
`STATUS` | `VARCHAR2(8)` |  | Enforcement status of constraint (`ENABLED` or `DISABLED`)
`DEFERRABLE` | `VARCHAR2(14)` |  | Whether the constraint is deferrable
`DEFERRED` | `VARCHAR2(9)` |  | Whether the constraint was initially deferred
`VALIDATED` | `VARCHAR2(13)` |  | Whether all data obeys the constraint (`VALIDATED` or `NOT VALIDATED`)
`GENERATED` | `VARCHAR2(14)` |  | Whether the name of the constraint is user or system generated
`BAD` | `VARCHAR2(3)` |  | A `YES` value indicates that this constraint specifies a century in an ambiguous manner. To avoid errors resulting from this ambiguity, rewrite the constraint using the `TO_DATE` function with a four-digit year. See Also: the `TO_DATE` function in Oracle Database SQL Reference and Oracle Database Application Developer's Guide - Fundamentals
`RELY` | `VARCHAR2(4)` |  | Whether an enabled constraint is enforced or unenforced. See Also: the constraints in Oracle Database SQL Reference
`LAST_CHANGE` | `DATE` |  | When the constraint was last enabled or disabled
`INDEX_OWNER` | `VARCHAR2(30)` |  | Name of the user owning the index
`INDEX_NAME` | `VARCHAR2(30)` |  | Name of the index (only shown for unique and primary-key constraints)
`INVALID` | `VARCHAR2(7)` |  | Whether the constraint is invalid
`VIEW_RELATED` | `VARCHAR2(14)` |  | Whether the constraint depends on a view